Tabela ToothState

Definicja tabeli ToothState

Name

ToothState

Code

ToothState

Comment

Stan calego zeba lub konkretnej jego czesci


Lista kolumn tabeli ToothState

Name

Code

ToothStateID

ToothStateID

ToothID

ToothID

ToothNo

ToothNo

ToothAreaID

ToothAreaID

ToothStateKindID

ToothStateKindID

PerfDT

PerfDT

Comments

Comments

ToothEndNo

ToothEndNo

IsAdditionalTooth

IsAdditionalTooth


Kolumna ToothStateID tabeli ToothState

Definicja kolumny ToothStateID tabeli ToothState

Name

ToothStateID

Code

ToothStateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID stanu zeba


Kolumna ToothID tabeli ToothState

Definicja kolumny ToothID tabeli ToothState

Name

ToothID

Code

ToothID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zeba


Kolumna ToothNo tabeli ToothState

Definicja kolumny ToothNo tabeli ToothState

Name

ToothNo

Code

ToothNo

Data Type

VARCHAR2(3)

Mandatory

No

Comment

Numer zeba


Kolumna ToothAreaID tabeli ToothState

Definicja kolumny ToothAreaID tabeli ToothState

Name

ToothAreaID

Code

ToothAreaID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID powierzchni zebowej


Kolumna ToothStateKindID tabeli ToothState

Definicja kolumny ToothStateKindID tabeli ToothState

Name

ToothStateKindID

Code

ToothStateKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu stanu zebowego


Kolumna PerfDT tabeli ToothState

Definicja kolumny PerfDT tabeli ToothState

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

Data wykonania


Kolumna Comments tabeli ToothState

Definicja kolumny Comments tabeli ToothState

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Uwagi dodatkowe


Kolumna ToothEndNo tabeli ToothState

Definicja kolumny ToothEndNo tabeli ToothState

Name

ToothEndNo

Code

ToothEndNo

Data Type

VARCHAR2(3)

Mandatory

No

Comment

numer zeba na którym konczy sie most


Kolumna IsAdditionalTooth tabeli ToothState

Definicja kolumny IsAdditionalTooth tabeli ToothState

Name

IsAdditionalTooth

Code

IsAdditionalTooth

Data Type

NUMBER(5)

Mandatory

No

Comment

flaga czy jest to zab dodatkowy


Lista kluczy tabeli ToothState

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ToothState

Definicja klucza Identifier_1 tabeli ToothState

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment